TPUG - Toronto PET Users Group/TPUG Users Group CD/TPUG Users Group CD.iso/AMIGA/AMICUS/AMICUS11.ADF/Analyze Templates/house.sht

The Works! Spreadsheet | 1986-08-05 | 21KB | 250 lines

'Household.sam.sht
@TODAY
'   AmiSoft!
'Household Budget
^YEAR
^INCOME
^TOTAL
^AVG.
'Main Gross pay
@SUM(B6..M6)
+N6/12
KP+O6/$O$14
'2nd Gross pay
@SUM(B7..M7)
+N7/12
+O7/$O$14
'Dividends/interest
@SUM(B8..M8)
+N8/12
+O8/$O$14
'other income
@SUM(B9..M9)
O+N9/12
+O9/$O$14
'other
+O10/$O$14
'other
@SUM(B11..M11)
+N11/12
+O11/$O$14
'other
@SUM(B12..M12)
+N12/12
+O12/$O$14
'TOTAL MONTH
@SUM(B6..B12)
@SUM(C6..C12)
@SUM(D6..D12)
@SUM(E6..E12)
@SUM(F6..F12)
@SUM(G6..G12)
@SUM(H6..H12)
@SUM(I6..I12)
@SUM(J6..J12)
@SUM(K6..K12)
@SUM(L6..L12)
H@SUM(M6..M12)
\)@SUM(B14..M14)
=q+N14/12
+O14/$O$14
    ^Monthly
^EXPENSES
^TOTAL
^AVG.
'PAYROLL TAXES
' FICA
@SUM(B20..M20)
+N20/12
+N20/$N$14
' STATE
@SUM(B21..M21)
+N21/12
7+N21/$N$14
' SOC. SEC.
@SUM(B22..M22)
+N22/12
+N22/$N$14
'House payment
@SUM(B23..M23)
+N23/12
+N23/$N$14
'Car payment
@SUM(B24..M24)
+N24/12
+N24/$N$14
'Investements
@SUM(B25..M25)
+N25/12
+N25/$N$14
'SCHOOL
@SUM(B26..M26)
+N26/12
`+N26/$N$14
' babysitting
+N27/$N$14
' books-equip-
@SUM(B28..M28)
+N28/12
+N28/$N$14
'INSURANCE
@SUM(B29..M29)
+N29/12
+N29/$N$14
    ' health
+N30/$N$14
' life
@SUM(B31..M31)
+N31/12
+N31/$N$14
' car-home-liab
@SUM(B32..M32)
+N32/12
`+N32/$N$14
'TAXES
@SUM(B33..M33)
+N33/12
+N33/$N$14
' property-car-boat
@SUM(B34..M34)
+N34/12
`+N34/$N$14
'Utilities
@SUM(B35..M35)
+N35/12
+N35/$N$14
' water-sewer
@SUM(B36..M36)
+N36/12
+N36/$N$14
' gas
@SUM(B37..M37)
+N37/12
*+N37/$N$14
' electricty
@SUM(B38..M38)
+N38/12
+N38/$N$14
' phone
@SUM(B39..M39)
UUUUU+N39/12
+N39/$N$14
' trash
@SUM(B40..M40)
+N40/12
+N40/$N$14
' cable
@SUM(B41..M41)
+N41/12
+N41/$N$14
'Subscriptions
@SUM(B42..M42)
UUUUU+N42/12
aN+N42/$N$14
'Donations
@SUM(B43..M43)
+N43/12
+N43/$N$14
    ' church
@SUM(B44..M44)
@'UUUUUU+N44/12
++N44/$N$14
' goodwill
@SUM(B45..M45)
+N45/12
+N45/$N$14
' pta-school
@SUM(B46..M46)
+N46/12
+N46/$N$14
' misc.
@SUM(B47..M47)
+N47/12
4+N47/$N$14
'Home maint.
@SUM(B48..M48)
+N48/12
D+N48/$N$14
    'Medical
@SUM(B49..M49)
+N49/12
l+N49/$N$14
'CAR REPAIR
@SUM(B50..M50)
@2UUUUUU+N50/12
+N50/$N$14
' car gas-oil
+I7-I50
@SUM(B51..M51)
+N51/12
]+N51/$N$14
'Food
@SUM(B52..M52)
+N52/12
@+N52/$N$14
'Entertainment
@SUM(B53..M53)
UUUUU+N53/12
+N53/$N$14
'Personal needs
@SUM(B54..M54)
+N54/12
+N54/$N$14
' clothes-shoes
@SUM(B55..M55)
UUUUU+N55/12
+N55/$N$14
'Misc
@SUM(B56..M56)
+N56/12
+N56/$N$14
'Misc
@SUM(B57..M57)
+N57/12
+N57/$N$14
'Misc
UUUUU+N58/12
+N58/$N$14
'Misc
@SUM(B59..M59)
+N59/12
+N59/$N$14
'Misc
@SUM(B60..M60)
+N60/12
+N60/$N$14
'TOTAL EXPENSES
@SUM(B23..B60)
@SUM(C23..C60)
@SUM(D23..D60)
@SUM(E23..E60)
@SUM(F23..F60)
@SUM(G23..G60)
@SUM(H23..H60)
@SUM(I23..I60)
@SUM(J23..J60)
@SUM(K23..K60)
@SUM(L23..L60)
@SUM(M23..M60)
@SUM(A62..M62)
+N62/12
+N62/$N$14
'CASH BALANCE
+B14-B62
+C14-C62
+D14-D62
+E14-E62
+F14-F62
+G14-G62
+H14-H62
+I14-I62
+J14-J62
+K14-K62
+L14-L62
+M14-M62
+N14-N62
+N63/12
+N63/$N$14
^TOTAL
^AVG.